Release 10.1A: OpenEdge Data Management:
SQL Reference

Relational operators

Relational operators specify how SQL compares expressions in basic and quantified predicates.

This is the syntax for a relational operator:

Syntax

= | <> | != | ^= | < | <= | > | >=

Table 49 lists the relational operators and the resulting predicates for each operator.

Table 49: Relational operators and resulting predicates 

Relational operator	Predicate for this relational operator
=	True if the two expressions are equal.
<> | != | ^=	True if the two expressions are not equal. The operators != and ^= are equivalent to <>.
<	True if the first expression is less than the second expression.
<=	True if the first expression is less than or equal to the second expression.
>	True if the first expression is greater than the second expression.
>=	True if the first expression is greater than or equal to the second expression.